﻿

CREATE PROCEDURE [dbo].[NonClusteredReport] 
AS
BEGIN
SELECT  [IndexID]
      ,[TableID]
      ,[IndexName]
      ,[IndexType]
      ,[IndexSize]
      ,[Statistics_LastUpdatedDate]
      ,[Fragmentation]
      ,[IS_PK]
      ,[IndexScans]
  FROM [SQLServerOptimizer].[dbo].[Index]
  WHERE IndexType = 'NONCLUSTERED INDEX'
END